USE [[DBASE]]

execute as user ='[BASEUSER]';

CREATE TABLE [BASESCHEMA]server_information (
    fieldname varchar(100) NOT NULL,
    fieldvalue varchar(100) NOT NULL
);

GRANT SELECT ON [BASESCHEMA]server_information TO "EVERYBODY";

INSERT INTO [BASESCHEMA]server_information VALUES ('serverdescription', '');
INSERT INTO [BASESCHEMA]server_information VALUES ('serveraddress', '');
INSERT INTO [BASESCHEMA]server_information VALUES ('servername', '');
INSERT INTO [BASESCHEMA]server_information VALUES ('providername', '');
INSERT INTO [BASESCHEMA]server_information VALUES ('individualname', '');
INSERT INTO [BASESCHEMA]server_information VALUES ('positionname', '');
INSERT INTO [BASESCHEMA]server_information VALUES ('phone', '');
INSERT INTO [BASESCHEMA]server_information VALUES ('email', '');
INSERT INTO [BASESCHEMA]server_information VALUES ('fax', '');
INSERT INTO [BASESCHEMA]server_information VALUES ('city', '');
INSERT INTO [BASESCHEMA]server_information VALUES ('administrativearea', '');
INSERT INTO [BASESCHEMA]server_information VALUES ('zip', '');
INSERT INTO [BASESCHEMA]server_information VALUES ('country', '');
INSERT INTO [BASESCHEMA]server_information VALUES ('deliverypoint', '');
INSERT INTO [BASESCHEMA]server_information VALUES ('accessconstraints', '');
INSERT INTO [BASESCHEMA]server_information VALUES ('fees', '');
INSERT INTO [BASESCHEMA]server_information VALUES ('poc', '');